2012-09-13 - 3939.400 - Spec - EMEA Customer Portal SAP extract #CustomerPortal #EMEA #ABAPEXTRACT
SPECIFICATIONS
3934.400 EMEA Customer Portal SAP extract
Purpose
New Era EMEA will be launching an order entry application for a select group of auto replenishment product. This is a marketing initiative we are joining other leading apparel companies on a solution provided by CenterStone Technologies. We will need to provide them with 4 files on an agreed upon basis.
Admin Info
Title
|
EMEA Customer Portal SAP extract
|
Requested By
|
Craig Spangler
|
Spec Created By
|
Venkat Kondapally
|
Spec Created Date
|
11/27/2012
|
Spec QA by
|
Venkat
|
Objects
|
Program :ZISD_EXT_EMEA_CUST_PORTAL
|
Status
(WIP/Complete)
|
Complete
|
References
Prior Tickets
Documents
Functional Requirement
Description
New Era EMEA will be launching an order entry application for a select group of auto replenishment product. This is a marketing initiative we are joining other leading apparel companies on a solution provided by CenterStone Technologies. We will need to provide them with 4 files on an agreed upon basis.
Overview and Scope
New Era will need a customer (CM), and price list (PL) material (ST) inventory/ATP (IN) files to be generated out of SAP, as well. Customer list is predefined, but the materials with be flagged using product attribute 6. All files will have to have the capability to be FTP transferred out of SAP.
Business Purpose
New Era Cap is looking to expand its reach in EMEA and this puts us in a single portal with many like companies.
Solution Summary
Discuss this section with Requester and get approval prior to beginning work
Develop a program which generates four files and these files are placed at FTP Server.
Files:
Customer (CM) File
Price List (PL) File
Material /Style (ST) File
Inventory/ATP (IN) File
Solution Details
Provide complete technical details for configuration or programming here.
Design
1 Product Attribute 6
Turn on the functionality to allow the Product Attribute 6 check box to be checked and unchecked. Change the description on the product attribute 6 to be “B2B Portal”.
MVKE - PRAT6
2 Inventory ATP File (IN)
2 .1File Layout
Name
|
Table
|
Field
|
Comments
|
UPC
|
MEAN
|
EAN11
|
|
Inventory
|
|
MCHB, J_3ABDBS, J_3ABDSI
|
This will be calculated ATP
|
InventorySource_cd
|
|
VKORG
|
|
2.2 Requirements
- Materials include in the file will be those with the Product Attribute 6 flag checked
- ATP should be restricted to Eersal, sales org 2000 plant 320
- The file will have to include the Field names in as headers
- File needs to be pipe “|” delimited.
- File will be named IN_NEYYYMMDDHHTT.txt
- Job to create file will run nightly
3 Style File (ST)
3.1File Layout
Name
|
Table
|
Field
|
Comments
|
Catalog
|
J_3ASEANT
|
TEXT
|
|
SupplierCatalogKey
|
J_3AMSEA
|
J_3ASEAN
|
|
ItemNumber
|
MARA
|
MATNR
|
|
ProductName
|
MAKT
|
MAKTX
|
|
Directory
|
MVKE
|
PRODH
|
This will be PH 01 description
|
Color
|
MARA
|
J_3ACOL join to J_3ACOLRT Text
|
If not maintained in SAP this should be NA
( Earlier this was picked from PMS Color (ZZPMSCOLOR) – 10/09/2012)
|
Size
|
MEAN
|
J_3AKORDX
|
|
UPC
|
MEAN
|
EAN11
|
|
MasterImage
|
MARA
|
MATNR
|
Materialid.jpg
|
3.2 Requirements
- Materials include in the file will be those with the Product Attribute 6 flag checked
- The file will have to include the Field names in as headers
- File needs to be pipe “|” delimited.
- File will be named ST_NEYYYMMDDHHTT.txt
- Job to create file will run nightly
- Apply Master Grid Sorting to file for displaying Grid. ( New Requirement – 10/25/2012 by Craig)
4.1 Customer Master (CM)
Name
|
Table
|
Field
|
Comments
|
C_AccountNum
|
KNA1
|
KUNNR
|
|
C_CompanyName
|
KNA1
|
NAME1
|
|
C_Address1
|
ADRC
|
HOUSE_NUM1, STREET
|
|
C_Address2
|
ADRC
|
STREET2
|
|
C_City
|
KNA1
|
ORT01
|
|
C_State
|
KNA1
|
REGIO
|
|
C_Zip
|
ADRC
|
POST_CODE1
|
|
C_Country
|
KNA1
|
LAND1
|
|
St_AccountNum
|
KNVP
|
KUNN2
|
|
St_StoreName
|
KNA1
|
NAME1
|
|
St_Address1
|
ADRC
|
HOUSE_NUM1, STREET
|
|
St_Address2
|
ADRC
|
STREET2
|
|
St_City
|
KNA1
|
ORT01
|
|
St_State
|
KNA1
|
REGIO
|
|
St_Zip
|
ADRC
|
POST_CODE1
|
|
St_Country
|
KNA1
|
LAND1
|
|
SR_Code
|
KNVV
|
VKGRP
|
|
Currency_cd
|
KNVV
|
WAERS
|
|
InventorySource
|
KNVV
|
VKORG
|
|
4.2 Requirements
- Will need to be written so that it can be run with variants, parameters sales org and customer id
- The file will have to include the Field names in as headers
- File needs to be pipe “|” delimited.
- File will be named CM_NEYYYMMDDHHTT.txt
- Job to create file will run nightly
5 Price List File (PL)
5.1 File Layout
Name
|
Table
|
Field
|
Comments
|
Currency_cd
|
KNOP
|
KONWA
|
|
UPC
|
MEAN
|
EAN11
|
|
Price
|
KNOP
|
KBETR
|
|
Units
|
KNOP
|
KMEIN
|
Need to be numerical EA = 1
|
Test Plan
List test scenarios/cases to be executed here
|
Test Scenario
|
1
|
Create Order do not allocate any quantity in the order
|
2
|
Create order and allocate quantity; do not deliver File
|
3
|
Create Order; Allocate Quantity and Deliver; do not PGI
|
4
|
Create Order; Allocate Quantity, Deliver and PGI
|
5
|
Compare Number of records with Material Master with number of Materials Flagged for product Attribute 6.
|
6
|
Check all materials in the file if they are flagged for Product Attribute 6
|
7
|
Change Supplier Catalog Key or Color etc
|
8
|
Create Conditions for Materials Flagged for Product Attribute 6
|
9
|
Change Price and UOM
|
10
|
Change Price
|
11
|
Change UOM
|
Issues